package com.foogui.booteasyexcel.vo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.format.NumberFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.foogui.booteasyexcel.converter.DateConverter;
import lombok.Data;

import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.Date;

@Data
public class ReqCustomerDailyImport {
    /**
     * 客户编码
     */
    @ExcelProperty(index = 0)
    private String customerName;
    /**
     * MIS编码
     */
    @ExcelProperty(index = 1)
    private String misCode;
    /**
     * 月度滚动额
     */
    @ExcelProperty(index = 2)
    private BigDecimal monthlyQuota;
    /**
     * 最新应收账款余额
     */
    @ExcelProperty(index = 3)
    private BigDecimal accountReceivableQuota;
    /**
     * 本月利率(年化）
     */
    @NumberFormat("#.##%")
    @ExcelProperty(index = 4)
    private BigDecimal dailyInterestRate;

    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
    @ExcelProperty(index = 5)
    private LocalDateTime date;
}
